package com.mysql.injector.method;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.core.injector.AbstractMethod;
import com.baomidou.mybatisplus.core.metadata.TableFieldInfo;
import com.baomidou.mybatisplus.core.metadata.TableInfo;
import com.baomidou.mybatisplus.core.metadata.TableInfoHelper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.baomidou.mybatisplus.core.toolkit.StringUtils;
import com.baomidou.mybatisplus.core.toolkit.sql.SqlScriptUtils;
import com.mysql.injector.enums.MySqlMethod;
import java.util.List;
import java.util.function.Predicate;
import org.apache.ibatis.executor.keygen.Jdbc3KeyGenerator;
import org.apache.ibatis.executor.keygen.KeyGenerator;
import org.apache.ibatis.executor.keygen.NoKeyGenerator;
import org.apache.ibatis.mapping.MappedStatement;
import org.apache.ibatis.mapping.SqlSource;

/**
 * 插入一条数据（重复存在更新）（非空判断）
 */
public class InsertOnDuplicateKeyUpdateBatchSomeColumn extends AbstractMethod {

  /**
   * 字段筛选条件
   */
  private final Predicate<TableFieldInfo> predicate;

  public InsertOnDuplicateKeyUpdateBatchSomeColumn(Predicate<TableFieldInfo> predicate) {
    super(MySqlMethod.INSERT_ON_DUPLICATE_KEY_UPDATE_BATCH_SOME_COLUMN.getMethod());
    this.predicate = predicate;
  }

  @Override
  @SuppressWarnings("Duplicates")
  public MappedStatement injectMappedStatement(Class<?> mapperClass, Class<?> modelClass, TableInfo tableInfo) {
    KeyGenerator keyGenerator = new NoKeyGenerator();
    MySqlMethod sqlMethod = MySqlMethod.INSERT_ON_DUPLICATE_KEY_UPDATE_BATCH_SOME_COLUMN;
    List<TableFieldInfo> fieldList = tableInfo.getFieldList();

    String insertSqlColumn =
      tableInfo.getKeyInsertSqlColumn(true, false) + this.filterTableFieldInfo(fieldList, predicate,
        TableFieldInfo::getInsertSqlColumn, EMPTY);
    String columnScript = LEFT_BRACKET + insertSqlColumn.substring(0, insertSqlColumn.length() - 1) + RIGHT_BRACKET;
    String insertSqlProperty =
      tableInfo.getKeyInsertSqlProperty(true, ENTITY_DOT, false) + this.filterTableFieldInfo(fieldList, predicate,
        i -> i.getInsertSqlProperty(ENTITY_DOT), EMPTY);
    insertSqlProperty = LEFT_BRACKET + insertSqlProperty.substring(0, insertSqlProperty.length() - 1) + RIGHT_BRACKET;
    String valuesScript =
      SqlScriptUtils.convertForeach(insertSqlProperty, Constants.COLL, null, Constants.ENTITY, COMMA);

    String sqlScript = String.format("`${%s}` = ${%s}", "key", "value");
    sqlScript = SqlScriptUtils.convertForeach(sqlScript, Constants.COLUMN_MAP, "key", "value", COMMA);
    sqlScript = SqlScriptUtils.convertChoose(
      String.format("%s != null and %s.size() > 0", Constants.COLUMN_MAP, Constants.COLUMN_MAP), sqlScript, " 1 = 1 ");
    String duplicateKeyUpdateScript = NEWLINE + sqlScript;

    String keyProperty = null;
    String keyColumn = null;
    // 表包含主键处理逻辑,如果不包含主键当普通字段处理
    if (StringUtils.isNotBlank(tableInfo.getKeyProperty())) {
      if (tableInfo.getIdType() == IdType.AUTO) {
        // 自增主键
        keyGenerator = new Jdbc3KeyGenerator();
        keyProperty = Constants.COLL + Constants.DOT + tableInfo.getKeyProperty();
        keyColumn = tableInfo.getKeyColumn();
      } else {
        if (null != tableInfo.getKeySequence()) {
          keyGenerator = TableInfoHelper.genKeyGenerator(sqlMethod.getMethod(), tableInfo, builderAssistant);
          keyProperty = tableInfo.getKeyProperty();
          keyColumn = tableInfo.getKeyColumn();
        }
      }
    }
    String sql =
      String.format(sqlMethod.getSql(), tableInfo.getTableName(), columnScript, valuesScript, duplicateKeyUpdateScript);
    SqlSource sqlSource = languageDriver.createSqlSource(configuration, sql, modelClass);
    return this.addInsertMappedStatement(mapperClass, modelClass, sqlMethod.getMethod(), sqlSource, keyGenerator,
      keyProperty, keyColumn);
  }

}
